'''

	This program will run the first of programs to replicate the figures and 
	tables from Martellini et al. work on college graduate quality.

'''

seed = 'C:/Users/jsock/Dropbox/Research/GD/International'

dataPath = seed + '/Data'
inputPath = seed + '/InputData'
figurePath = seed + '/Replication/Figures'
tablePath = seed + '/Replication/Tables'
estimatePath = seed + '/Replication/Estimates'
tempPath = seed + '/Replication/TempData'

pythonPath = seed + '/Replication/Python'
stataPath = seed + '/Replication/Stata'

#----------------------------------------------------
# Section A: Extracting the Glassdoor data
#----------------------------------------------------

'''
A) R_extract_salaries.py
	
	Description: Extract user-submitted salary reports for all countries to Glassdoor.
	Output: International_salaries_07_13_2022.csv
'''

#execfile(pythonPath + '/R_extract_salaries.py')

'''
B) R_extract_resumes_educ.py
	
	Description: Extract worker's educational histories provided in resumes to Glassdoor.
	Output: Resumes_educ_07_16_2022.csv
'''

#execfile(pythonPath + '/R_extract_resumes_educ.py')

'''
C) R_extract_resumes_workexp.py
	
	Description: Extract worker's work histories provided in resumes to Glassdoor.
	Output: Resumes_workexp_birthYear_STARTYEAR_ENDYEAR_01_03_2022.csv
 		Resumes_workexp_noBirthYear_01_03_2022.csv
'''

#execfile(pythonPath + '/R_extract_resumes_workexp.py')

#----------------------------------------------------
# Section B: Compiling the Glassdoor data
#----------------------------------------------------

'''
	A) R_create_clean_users_schools_majors.py
		
		Description: Uniformizes and assigns colleges, majors, and degrees to each worker based on their resume.
		Output: Cleaned_user_schools_majors.csv
'''

execfile(pythonPath + '/R_create_clean_user_schools_majors.py')

'''
	B) R_create_resumes_work_exp.py
	
	Description: Determines whether the worker ever had a c-suite or founder job pased on their resume work experience.
	Output: User_founder_csuite.csv
'''

execfile(pythonPath + '/R_create_resumes_work_exp.py')

'''
	C) R_create_US_scorecard.py
		
		Description: Reads in the US DoE's College Scorecard and collapse to college-major based on coarser majors for merging with Glassdoor.
		Output: US_scorecard_earnings.csv
'''

execfile(pythonPath + '/R_create_US_scorecard.py')

'''
	D) R_create_salaries_international.py
		
		Description: Produces the main pay dataset by merging Glassdoor data with the cleaned resume data.
		Output: Salaries_international_dataset_main.csv
'''

execfile(pythonPath + '/R_create_salaries_international.py')
